{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"DBFNAME","type":"character","width":8},{"name":"DESCRIPT","type":"character","width":30},{"name":"INDEXNAME","type":"character","width":8},{"name":"INDEXEXP","type":"character","width":64},{"name":"NCXEXP","type":"character","width":64},{"name":"UNIQUE","type":"character","width":1},{"name":"REINDEX","type":"logical","width":1},{"name":"RESET_TYPE","type":"character","width":1},{"name":"LOCALWORK","type":"logical","width":1}],"n_rows":79,"rows_kept":79,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
["ACCOUNTS","Store Accounts by Invoice","ACCTINVC","INVOICE","INVOICE","0",false,"H",null]
["ACCOUNTS","Store Accounts by Name","ACCTNAME","LEFT(UPPER(NAME),8)","LEFT(UPPER(NAME),8)","0",false,null,null]
["ACCOUNTS","Store Accounts by Customer #","ACCTCUST","CUSTNUMB","CUSTNUMB","0",false,null,null]
["ACNTPAY","Accounts Payable","ACNTPAY","DUE_DATE","DUE_DATE","0",false,"H",null]
["CATEGORY","SKU Categories","CATEGORY","DEPARTMENT+UPPER(LEFT(DESCRIPT,10))","DEPARTMENT+UPPER(LEFT(DESCRIPT,6))","0",false,"S",null]
["CATEGORY","Categories By Dept & Number","CATEGNUM","DEPARTMENT+NUMBER","DEPARTMENT+NUMBER","1",false,"S",null]
["CONTROL","Store Information / Settings",null,null,null,null,false,"S",null]
["CREDITS","Store Acct Paymnt by Customer","CREDCUST","CUSTNUMB","CUSTNUMB","0",false,"H",null]
["CREDITS","Store Acct Paymnt By Date","CREDDATE","DATE_PAID","DATE_PAID","0",false,null,null]
["CREDITS","Store Credits by Invoice","CREDINV","INVOICE","INVOICE","0",false,null,null]
["CTRLSWIT","System Control Switches","CTRLSWIT","SWITCH_NUM","SWITCH_NUM","1",false,"S",null]
["CTRLVAL","Store Control Values","CTRLVAL","VAL_NUM","VAL_NUM","1",false,"S",null]
["CUSTMAIL","Customer Mail List File","CUSTMAIL","CUSTNUMB","CUSTNUMB","1",false,"H",true]
["CUSTOMER","Customer Master File: By Name","CUSTNAME","UPPER(LNAME+LEFT(FNAME,5))","UPPER(LEFT(LNAME,10)+LEFT(FNAME,5))","0",false,"A",null]
["CUSTOMER","Customer Master File:By Number","CUSTNUMB","CUSTNUMB","CUSTNUMB","1",false,null,null]
["CUSTOMER","Customer Master File: By Phone","CUSTFONE","RIGHT(SPACE(4)+TRIM(HOME_NUM),4)","LEFT(TRIM(HOME_NUM)+'    ', 4)","0",false,null,null]
["DBFINFO","Database Index Driver","DBFINFO","DBFNAME","DBFNAME","0",false,"S",null]
["DEPTS","Department Numbers","DEPTNUM","DEPT_NUM","DEPT_NUM","1",true,"S",null]
["DEPTS","Department Names","DEPTNAME","DEPARTMENT","DEPARTMENT","0",true,"S",null]
["DISCOUNT","Store Discount Choices",null,null,null,null,false,"S",null]
["EMPLOYEE","Employee Numbers","EMPLOYEE","EMPLOY_NUM","EMPLOY_NUM","1",false,"S",null]
["EMPLOYEE","Employee Name List","EMPLNAME","UPPER(LEFT(LNAME,6)+LEFT(FNAME,6))","UPPER(LEFT(LNAME,6)+LEFT(FNAME,6))","0",false,"S",null]
["EMPLSTAT","Employee Status Codes",null,null,null,null,false,"S",null]
["ESTCUST","Customer Estimates : By Name","ESTNAME","UPPER(LNAME+FNAME)","*UPPER(LNAME+FNAME)","0",false,"A",null]
["ESTCUST","Customer Estimates : By Number","ESTNUMB","ESTNUMB","*ESTNUMB","1",false,null,null]
["ESTIMATE","Estimate Items by Estimate #","ESTIMATE","ESTNUMBER","*ESTNUMBER","0",false,"A",null]
["INVENTRY","Inventory File By SKU Number","INVENSKU","SKUCODE","SKUCODE","1",false,"S",null]
["JOURFORM","Journal Template File",null,null,null,null,false,null,null]
["JOURNAL","Electronic Journal Invoice #","JOURNAL","INVOICE","*INVOICE","0",false,"H",null]
["LABORS","Canned Labor Descriptions","LABORS","DEPT+CATEGORY+LEFT(UPPER(DESCRIPT),5)","*DEPT+CATEGORY+LEFT(UPPER(DESCRIPT),5)","0",false,"S",null]
["LABORS","Labor Descriptions by Number","LABORNUM","DEPT+CATEGORY+TYPE","*DEPT+CATEGORY+TYPE","1",false,"S",null]
["LABRATES","Labor Rates per Hour",null,null,null,null,false,"S",null]
["LAYCUST","Layaway Accounts by Name","LAYCUSTC","UPPER(LEFT(LNAME,8)+LEFT(FNAME,8))","UPPER(LEFT(LNAME,8)+LEFT(FNAME,8))","0",false,"H",null]
["LAYCUST","Layaway Accounts by Number","LAYCUSTN","LAYNUMB","LAYNUMB","1",false,null,null]
["LAYCUST","Layaway Accounts by Date","LAYCUSTD","DATE_IN","DATE_IN","0",false,null,null]
["LAYITEM","Layaway Account Items","LAYITEM","LAYNUMB","LAYNUMB","0",false,"H",null]
["LAYPAYMT","Layaway Account Payments","LAYPAYMT","LAYNUMB","LAYNUMB","0",false,"H",null]
["LAYPAYMT","Layaway Account Payments Inv.","LAYPYINV","INVOICE","INVOICE","0",false,null,null]
["LEDGER","System Account Ledger","LEDGER","DATE","DATE","1",false,"A",null]
["MENUS","Menus by Name","MENUS","MENU_FORM","MENU_FORM","0",false,"S",null]
["MONTHLOG","Log of Journal Files by Month",null,null,null,null,false,"H",null]
["NOTAX","Non-Taxable Sales Journal","NOTAX","CUSTNUMB","CUSTNUMB","0",false,"H",null]
["NOTICODE","Customer Notifier Codes","NOTICODE","NOTE_CODE","NOTE_CODE","1",false,"S",false]
["NOTIFIER","Customer Notifier List","NOTIFIER","DATE_SEND","DATE_SEND","0",false,"A",false]
["PACKCODE","Stock Pack Codes","PACKCODE","PACK_CODE","PACK_CODE","1",false,"S",null]
["PACKCODE","Stock Pack Codes by Value","PACKNUMB","PACK_UNITS","PACK_UNITS","0",false,"S",null]
["PACKDBF","Closing File Maintenance","PACKDBF","DBFNAME","DBFNAME","1",false,"S",null]
["PAYOUTS","Register Payouts By Date","PAYOUTS","DATE+PAYREASON","DTOS(DATE)+PAYREASON","0",false,"H",null]
["PAYOUTS","Payouts by Reason+Date","PAYREASN","PAYREASON+DATE","PAYREASON+DTOS(DATE)","0",false,null,null]
["PAYOUTS","Payouts Sorted By Vendor","PAYVENDR","STR(VENDOR,5)+DATE+PAYREASON","STR(VENDOR,5)+PAYREASON+DTOS(DATE)","0",false,null,null]
["PAYTYPES","Payout Types/Reason Codes","PAYTYPES","PAYREASON","PAYREASON","1",false,"S",null]
["PAYTYPES","Payout Reason Names Sort","PAYRENAM","UPPER(LEFT(DESCRIPT,8))","UPPER(LEFT(DESCRIPT,8))","0",false,"S",null]
["PRINTERS","Printer Driver File",null,null,null,null,false,"S",null]
["PRODTOTL","Work File for Sales Analysis",null,null,null,null,false,"H",null]
["RCPHEAD","Receipt Header Information",null,"TYPE+REFERENCE","TYPE+REFERENCE","0",false,"H",true]
["RCPITEMS","Receipt Items Data",null,"TYPE","TYPE","0",false,"H",true]
["RCPMSG","Receipt Trailer Messages","RCPMSG","TYPE+REFERENCE","TYPE+REFERENCE","1",false,"S",null]
["RECVITEM","PO/Receiving Items","RECVITEM","REF_NUM","*REF_NUM","0",false,"H",null]
["RECVLOG","PO/Receiving Log","RECVLOG","REF_NUM","*REF_NUM","0",false,"H",null]
["RECVLOG","Received Items Log - By Date","RECPDATE","POST_DATE","*POST_DATE","0",false,null,null]
["REPORTS","Report Menu Options","REPORTS","RPTREFNUM","RPTREFNUM","1",false,"S",null]
["SALETYPE","Sale Types","SALETYPE","SALETYPE","SALETYPE","1",false,"S",false]
["SETLIST","SKU Sets List","SETLIST","SET_NUMBER","*SET_NUMBER","1",false,"S",null]
["SKUFILE","SKU Numbers By Category","SKUCATEG","DEPT+CATEGORY+UPPER(LEFT(DESCRIPT,6))","DEPT+CATEGORY+UPPER(LEFT(DESCRIPT,6))","0",false,"S",null]
["SKUFILE","SKU File By SKU Numbers","SKUCODE","SKUCODE","SKUCODE","1",false,"S",null]
["SKUSETS","SKU Numbers For Sets","SKUSETS","SET_NUMBER","*SET_NUMBER","0",false,"S",null]
["TAXCODES","Customer Taxcodes","TAXCODES","TAXTYPE+TAXCATEG","TAXTYPE+TAXCATEG","1",false,"S",null]
["TENDDATA","Extended Tendering Info","TENDDATA","STR(INVOICE,8)+TENDERNUM","*STR(INVOICE,8)+TENDERNUM","0",false,"H",null]
["TENDLOG","Transaction Log By Number","TENDNUMB","INVOICE","INVOICE","0",false,"H",null]
["TENDLOG","Transaction Log By Date","TENDDATE","DATE","DATE","0",false,null,null]
["TENDLOG","Transaction Log By Customer","TENDCUST","CUSTNUMB","CUSTNUMB","0",false,null,null]
["TENDTYPE","Tender Choices File","TENDTYPE","TENDERNUM","TENDERNUM","1",false,"S",null]
["TOTAL","Register Totals By Date","TOTALS","DATE","DATE","0",false,"H",null]
["VENDORS","Vendors by Number","VENDNUMB","VENDOR","VENDOR","1",false,"A",null]
["VENDORS","Vendors by Name","VENDNAME","UPPER(LEFT(NAME,8))","UPPER(LEFT(NAME,8))","0",false,null,null]
["WEEKCAL","Fiscal Week Calendar","WEEKCAL","END","*END","1",false,"S",null]
["WORKDATA","Work Station Information",null,null,null,null,false,"S",null]
["ZIPCODES","City ZIP / Postal Codes","ZIPCODES","POSTALCODE","POSTALCODE","1",false,"A",null]
["SKMATRIX","Sku Item Matrix","SKMATRIX","UPPER(MATRIXNAME)","*UPPER(MATRIXNAME)","0",false,"S",false]